USE [master]

/****** Object:  Database [IntelligentStackerSystem]    Script Date: 07/30/2021 13:18:02 ******/
CREATE DATABASE [IntelligentStackerSystem] ON  PRIMARY 
( NAME = N'DB_ISS', FILENAME = N'E:\IntelligentStackerSystemDataBase\DB_ISS.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'DB_ISS_log', FILENAME = N'E:\IntelligentStackerSystemDataBase\DB_ISS_log.ldf' , SIZE = 73728KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )

ALTER DATABASE [IntelligentStackerSystem] SET COMPATIBILITY_LEVEL = 100

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [IntelligentStackerSystem].[dbo].[sp_fulltext_database] @action = 'enable'
end

ALTER DATABASE [IntelligentStackerSystem] SET ANSI_NULL_DEFAULT OFF

ALTER DATABASE [IntelligentStackerSystem] SET ANSI_NULLS OFF

ALTER DATABASE [IntelligentStackerSystem] SET ANSI_PADDING OFF

ALTER DATABASE [IntelligentStackerSystem] SET ANSI_WARNINGS OFF

ALTER DATABASE [IntelligentStackerSystem] SET ARITHABORT OFF

ALTER DATABASE [IntelligentStackerSystem] SET AUTO_CLOSE OFF

ALTER DATABASE [IntelligentStackerSystem] SET AUTO_CREATE_STATISTICS ON

ALTER DATABASE [IntelligentStackerSystem] SET AUTO_SHRINK OFF

ALTER DATABASE [IntelligentStackerSystem] SET AUTO_UPDATE_STATISTICS ON

ALTER DATABASE [IntelligentStackerSystem] SET CURSOR_CLOSE_ON_COMMIT OFF

ALTER DATABASE [IntelligentStackerSystem] SET CURSOR_DEFAULT  GLOBAL

ALTER DATABASE [IntelligentStackerSystem] SET CONCAT_NULL_YIELDS_NULL OFF

ALTER DATABASE [IntelligentStackerSystem] SET NUMERIC_ROUNDABORT OFF

ALTER DATABASE [IntelligentStackerSystem] SET QUOTED_IDENTIFIER OFF

ALTER DATABASE [IntelligentStackerSystem] SET RECURSIVE_TRIGGERS OFF

ALTER DATABASE [IntelligentStackerSystem] SET  DISABLE_BROKER

ALTER DATABASE [IntelligentStackerSystem] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

ALTER DATABASE [IntelligentStackerSystem] SET DATE_CORRELATION_OPTIMIZATION OFF

ALTER DATABASE [IntelligentStackerSystem] SET TRUSTWORTHY OFF

ALTER DATABASE [IntelligentStackerSystem] SET ALLOW_SNAPSHOT_ISOLATION OFF

ALTER DATABASE [IntelligentStackerSystem] SET PARAMETERIZATION SIMPLE

ALTER DATABASE [IntelligentStackerSystem] SET READ_COMMITTED_SNAPSHOT OFF

ALTER DATABASE [IntelligentStackerSystem] SET HONOR_BROKER_PRIORITY OFF

ALTER DATABASE [IntelligentStackerSystem] SET  READ_WRITE

ALTER DATABASE [IntelligentStackerSystem] SET RECOVERY FULL

ALTER DATABASE [IntelligentStackerSystem] SET  MULTI_USER

ALTER DATABASE [IntelligentStackerSystem] SET PAGE_VERIFY CHECKSUM

ALTER DATABASE [IntelligentStackerSystem] SET DB_CHAINING OFF

EXEC sys.sp_db_vardecimal_storage_format N'IntelligentStackerSystem', N'ON'
